Bike Share Case Study
Data: from 2021-09-06 to 2022-09-06. This analysis is to study how different annual members and casual riders used Cyclistic bikes.
1. Overall
The table below shows the summary of trip length statistics (in seconds).
- Annual members rode more trips than casual riders, but the trip length of casual rides are 2.3 times longer than that of annual members.
- Average trip length of
- all members: 1180 seconds (or 19 minutes)
- casual riders: 1754 seconds (or 29 minutes)
- annual members: 770 seconds (or 12 minutes)
| DataType1 | TripCount | TripCountPercent | Min_Length2 | Q1_Length3 | Median_Length4 | Mean_Length5 | Q3_Length6 | Max_Length7 |
|---|---|---|---|---|---|---|---|---|
| all | 5,748,185 | 100% | 0 | 362 | 640 | 1,180 | 1,154 | 2,442,301 |
| casual | 2,396,331 | 41.7% | 0 | 472 | 830 | 1,754 | 1,524 | 2,442,301 |
| member | 3,351,854 | 58.3% | 0 | 311 | 537 | 770 | 931 | 93,594 |
| 1 all - all trips, casual - trips made by casual riders, member - trips made by annual members | ||||||||
| 2 Min_Length: minimum trip length | ||||||||
| 3 Q1_Length: 25% of the trips have their length below Q1 | ||||||||
| 4 Median_Length: 50% of the trips have their length below median | ||||||||
| 5 Mean_Length: the average trip length | ||||||||
| 6 Q3_Length: 75% of thr trips have their length below Q3 | ||||||||
| 7 Max_Length: maximum trip length | ||||||||
2. Number of rides
- The number of trips decreased during the winter season from November to February.
- The same pattern were seen for both groups, casual riders and annual members.
By Day
By Month
3. Trip length
- The trip length outside 1.5 interquartile range (IQR = Q3 - Q1) or longer than 2342 seconds (or approximately 39 minutes) was considered outliers and excluded from the following charts.
- The trip length during winter season from November to February was shorter than that of the other months.
Trip Length by Month
Trip Length by User Type
Trip Length by Month and User Type
4. By day of week
- Averagely, weekends had more rides than weekdays. The trend was opposite during winter months from November to February, when Monday to Thursday had more rides than other days.
- The trip length were longer during weekends, and the trend kept consistent throughout the year.
Average number of rides per day by day of week
All
Nov - Feb
Mar - Oct
Trip Length by day of week
- Mar-Oct vs. Nov-Feb
Trip Length by day of week by user type
